FO_Merge_Rule_Definition
This table contains rule definitions for both automated and non-automated merges.
| Field | Type | Notes |
|---|---|---|
|
MergeRuleDef_ID |
int |
ID field, a counter. Unique |
|
RuleName |
varchar(255) |
Enter a user-friendly rule name. |
|
RuleCode |
varchar(50) |
Code for Rule |
|
Notes |
varchar(MAX) |
Informational |
|
AutoMergeRule |
bit |
Bit flag that indicates if the automerge rule is in effect. Enter 0 or 1 0 = FALSE, not automated merge rule. Must be manually reviewed and QUEUED to merge. 1 = TRUE, automatic merge rule. Merge process will occur without user intervention. |
|
LastRunDate |
datetime |
Timestamp when rule was last executed. |
|
SelectSQL |
varchar(MAX) |
Enter a SQL statement or stored procedure name. |